﻿IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_exhibiter]') AND TYPE in (N'U'))
BEGIN
CREATE TABLE tb_exhibiter
(
    Id INT IDENTITY(1,1) NOT NULL,
	ExhibiterName varchar(200) not null,
	meipai varchar(200) not null,
	Address varchar(500) not null,
	country varchar(20),
	xingzhi varchar(200) default(''),
	PhoneNumber varchar(20) not null default(''),
	FoxNumber varchar(20) not null default(''),
	Introduce varchar(max) not null,
	homepage varchar(max) not null,
	logo varchar(500),
	ExhibitionContent varchar(4000) not null default(''), --参展内容
	Contact1 varchar(20) not null default(''), --联系人
	Contact1Address varchar(400) not null default(''), --称呼
	Contact1Title varchar(400) not null default(''),
	Contact1Email varchar(400) not null default(''),
	Contact1Phone varchar(400) not null default(''),
	Contact2 varchar(20) not null default(''), --联系人
	Contact2Address varchar(400) not null default(''), --称呼
	Contact2Title varchar(400) default(''),
	Contact2Email varchar(400) default(''),
	Contact2Phone varchar(400) default(''),
	JoinTimes int, --参加次数
	StandardCount int not null default(0), --标准展位，单位（个）
	OpenSpace int not null default(0), --光地展位，单位（平方米）
	Requirement varchar(max), --参展要求
	BuinessScope varchar(max), --经营范围
    CreateBy VARCHAR(100),
    CreateDate DATETIME DEFAULT(GETDATE()),
    UpdateBy VARCHAR(100),
    UpdateDate DATETIME,
	CONSTRAINT PK_exhibiter_Id PRIMARY KEY CLUSTERED (Id)
) 
END
GO